﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using DataAccessLogic;

namespace BusinessLogic
{
    public class State : FormattedCodeTable
    {
        public State() : base() { }
        public State(Guid id) : base(id) { }

        public static List<State> GetAll()
        {
            return DataAccess.Address_DA.GetStates();
        }

        public override DatabaseInteractionDescriptor TableInteractionDescription()
        {
            DatabaseInteractionDescriptor result = new DatabaseInteractionDescriptor();
            result.CreateStoredProcedure = DataAccessLogic.StoredProcedures.USP_STATEFORMATTEDTYPECODE_CREATE;
            result.GetByIDStoredProcedure = DataAccessLogic.StoredProcedures.USP_STATEFORMATTEDTYPECODE_GETBYID;
            result.DeleteStoredProcedure = DataAccessLogic.StoredProcedures.USP_STATEFORMATTEDTYPECODE_DELETE;
            return result;
        }
    }
}